train_df_final Data Summary Report

Dataset statistics

Number of variables	38
Number of observations	1620
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	411.5 KiB
Average record size in memory	260.1 B

Variable types

Numeric	24
Categorical	9
DateTime	5

Warnings

`msno` has a high cardinality: 1620 distinct values	High cardinality
`bd` is highly correlated with `gender`	High correlation
`gender` is highly correlated with `bd`	High correlation
`total_payment_channels` is highly correlated with `total_transactions` and 3 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan`	High correlation
`payment_plan_days_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `change_in_payment_methods`	High correlation
`plan_list_price_mean` is highly correlated with `payment_plan_days_mean` and 1 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `payment_plan_days_mean` and 1 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `is_autorenew_change_flag`	High correlation
`is_autorenew_change_flag` is highly correlated with `is_auto_renew_mean`	High correlation
`total_transactions` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag`	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean`	High correlation
`discount_mean` is highly correlated with `is_discount_mean` and 1 other fields	High correlation
`is_discount_mean` is highly correlated with `discount_mean` and 1 other fields	High correlation
`is_discount_max` is highly correlated with `discount_mean` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`num_25` is highly correlated with `num_50` and 3 other fields	High correlation
`num_50` is highly correlated with `num_25` and 2 other fields	High correlation
`num_75` is highly correlated with `num_25` and 2 other fields	High correlation
`num_985` is highly correlated with `num_25` and 2 other fields	High correlation
`num_100` is highly correlated with `num_unq` and 1 other fields	High correlation
`num_unq` is highly correlated with `num_25` and 2 other fields	High correlation
`total_secs` is highly correlated with `num_100` and 1 other fields	High correlation
`login_freq` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`registration_duration` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`bd` is highly correlated with `gender`	High correlation
`gender` is highly correlated with `bd`	High correlation
`total_payment_channels` is highly correlated with `total_transactions` and 3 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `change_in_payment_methods`	High correlation
`plan_list_price_mean` is highly correlated with `actual_amount_paid_mean` and 2 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `plan_list_price_mean` and 2 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `change_in_payment_methods` and 3 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `is_auto_renew_mean`	High correlation
`total_transactions` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag`	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean`	High correlation
`discount_mean` is highly correlated with `is_discount_mean` and 1 other fields	High correlation
`is_discount_mean` is highly correlated with `discount_mean` and 1 other fields	High correlation
`is_discount_max` is highly correlated with `discount_mean` and 1 other fields	High correlation
`amt_per_day_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`num_25` is highly correlated with `num_50` and 2 other fields	High correlation
`num_50` is highly correlated with `num_25` and 2 other fields	High correlation
`num_75` is highly correlated with `num_25` and 2 other fields	High correlation
`num_985` is highly correlated with `num_25` and 2 other fields	High correlation
`num_100` is highly correlated with `num_unq` and 1 other fields	High correlation
`num_unq` is highly correlated with `num_100` and 1 other fields	High correlation
`total_secs` is highly correlated with `num_100` and 1 other fields	High correlation
`login_freq` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`registration_duration` is highly correlated with `total_payment_channels` and 3 other fields	High correlation
`bd` is highly correlated with `gender`	High correlation
`gender` is highly correlated with `bd`	High correlation
`total_payment_channels` is highly correlated with `total_transactions` and 2 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan` and 1 other fields	High correlation
`change_in_plan` is highly correlated with `change_in_payment_methods`	High correlation
`plan_list_price_mean` is highly correlated with `actual_amount_paid_mean` and 1 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `change_in_payment_methods` and 1 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `is_auto_renew_mean`	High correlation
`total_transactions` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag`	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean`	High correlation
`discount_mean` is highly correlated with `is_discount_mean` and 1 other fields	High correlation
`is_discount_mean` is highly correlated with `discount_mean` and 1 other fields	High correlation
`is_discount_max` is highly correlated with `discount_mean` and 1 other fields	High correlation
`amt_per_day_mean` is highly correlated with `plan_list_price_mean` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`num_25` is highly correlated with `num_50`	High correlation
`num_50` is highly correlated with `num_25` and 1 other fields	High correlation
`num_75` is highly correlated with `num_50` and 1 other fields	High correlation
`num_985` is highly correlated with `num_75`	High correlation
`num_100` is highly correlated with `num_unq` and 1 other fields	High correlation
`num_unq` is highly correlated with `num_100` and 1 other fields	High correlation
`total_secs` is highly correlated with `num_100` and 1 other fields	High correlation
`registration_duration` is highly correlated with `total_payment_channels` and 2 other fields	High correlation
`change_in_plan` is highly correlated with `amt_per_day_mean` and 8 other fields	High correlation
`amt_per_day_mean` is highly correlated with `change_in_plan` and 11 other fields	High correlation
`city` is highly correlated with `bd` and 3 other fields	High correlation
`total_transactions` is highly correlated with `change_in_plan` and 4 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `amt_per_day_mean` and 5 other fields	High correlation
`is_churn` is highly correlated with `is_autorenew_change_flag` and 2 other fields	High correlation
`bd` is highly correlated with `city` and 2 other fields	High correlation
`is_auto_renew_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`payment_plan_days_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`change_in_payment_methods` is highly correlated with `change_in_plan` and 2 other fields	High correlation
`total_payment_channels` is highly correlated with `change_in_plan` and 4 other fields	High correlation
`num_985` is highly correlated with `num_50` and 1 other fields	High correlation
`is_cancel_change_flag` is highly correlated with `is_cancel_mean` and 1 other fields	High correlation
`is_cancel_mean` is highly correlated with `is_cancel_change_flag` and 1 other fields	High correlation
`num_50` is highly correlated with `num_985` and 3 other fields	High correlation
`num_75` is highly correlated with `num_985` and 2 other fields	High correlation
`is_discount_max` is highly correlated with `amt_per_day_mean` and 3 other fields	High correlation
`transaction_date_max` is highly correlated with `change_in_plan` and 10 other fields	High correlation
`membership_expire_date_max` is highly correlated with `amt_per_day_mean` and 8 other fields	High correlation
`login_freq` is highly correlated with `total_transactions` and 3 other fields	High correlation
`gender` is highly correlated with `city` and 1 other fields	High correlation
`plan_list_price_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`registration_duration` is highly correlated with `change_in_plan` and 5 other fields	High correlation
`is_discount_mean` is highly correlated with `is_discount_max` and 1 other fields	High correlation
`num_25` is highly correlated with `num_50` and 2 other fields	High correlation
`total_secs` is highly correlated with `num_unq` and 1 other fields	High correlation
`more_than_30_sum` is highly correlated with `change_in_plan` and 8 other fields	High correlation
`actual_amount_paid_mean` is highly correlated with `amt_per_day_mean` and 4 other fields	High correlation
`num_unq` is highly correlated with `num_50` and 3 other fields	High correlation
`discount_mean` is highly correlated with `change_in_plan` and 3 other fields	High correlation
`registered_via` is highly correlated with `change_in_plan` and 8 other fields	High correlation
`num_100` is highly correlated with `total_secs` and 1 other fields	High correlation
`is_autorenew_change_flag` is highly correlated with `registered_via`	High correlation
`registered_via` is highly correlated with `is_autorenew_change_flag`	High correlation
`membership_duration_mean` is highly skewed (γ1 = -37.92216912)	Skewed
`msno` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`msno` has unique values	Unique
`is_auto_renew_mean` has 237 (14.6%) zeros	Zeros
`is_cancel_mean` has 1395 (86.1%) zeros	Zeros
`discount_mean` has 1438 (88.8%) zeros	Zeros
`is_discount_mean` has 1520 (93.8%) zeros	Zeros
`more_than_30_sum` has 210 (13.0%) zeros	Zeros
`num_25` has 70 (4.3%) zeros	Zeros
`num_50` has 265 (16.4%) zeros	Zeros
`num_75` has 410 (25.3%) zeros	Zeros
`num_985` has 405 (25.0%) zeros	Zeros
`num_100` has 22 (1.4%) zeros	Zeros

Reproduction

Analysis started	2023-05-19 11:03:22.350799
Analysis finished	2023-05-19 11:04:39.829980
Duration	1 minute and 17.48 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

UNIQUE

Distinct	1620
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	164011.6519

Minimum	46
Maximum	323899
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	46
5-th percentile	18563.4
Q1	84342
median	162677.5
Q3	245104.25
95-th percentile	308231.75
Maximum	323899
Range	323853
Interquartile range (IQR)	160762.25

Descriptive statistics

Standard deviation	93348.64663
Coefficient of variation (CV)	0.5691586273
Kurtosis	-1.201181249
Mean	164011.6519
Median Absolute Deviation (MAD)	80650.5
Skewness	-0.00572715963
Sum	265698876
Variance	8713969827
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
97370	1	0.1%
259561	1	0.1%
263695	1	0.1%
18565	1	0.1%
259679	1	0.1%
226247	1	0.1%
283381	1	0.1%
259642	1	0.1%
231922	1	0.1%
152819	1	0.1%
Other values (1610)	1610	99.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
46	1	0.1%
398	1	0.1%
598	1	0.1%
674	1	0.1%
734	1	0.1%
954	1	0.1%
1319	1	0.1%
1429	1	0.1%
1469	1	0.1%
2066	1	0.1%

Value	Count	Frequency (%)
323899	1	0.1%
323744	1	0.1%
323650	1	0.1%
323456	1	0.1%
323362	1	0.1%
323344	1	0.1%
323169	1	0.1%
322821	1	0.1%
322465	1	0.1%
322156	1	0.1%

msno
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	1620
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44=	1
4iUeTCbgS85/LHCudzqRUY9K7uZUaV+XmTLjIYUF23I=	1
2+xPFcvkGfuCT8qR0zgaokU5UZCNYMgNb81CNU/P9Go=	1
JpWaI65ySCqcBU8OPLZzhthGVmXDl0ELqJmy7U92MHg=	1
sJwXclAfmrjPjVl/cqyVKVP7kjERclaUtbs/dhr2Obs=	1
Other values (1615)	1615

Length

Max length	44
Median length	44
Mean length	44
Min length	44

Characters and Unicode

Total characters	71280
Distinct characters	65
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1620 ?
Unique (%)	100.0%

Sample

1st row	w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44=
2nd row	cnncNsMOZE3kiTKQNSBbVCJMdE+PKr56pBYYeHWJ8Zk=
3rd row	aWZDoNfiZtG0IWeC0++ocJXLZORBwDvkYA2rCBA4yAs=
4th row	Ph7IvMxuu+1hJp8qYOAy5llX7D97espKsmhEgicBKls=
5th row	cdrXUooJ9G1gXiLFd5NWqQ5HpgmNzl0aeaojPBJ203k=

Common Values

Value	Count	Frequency (%)
w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44=	1	0.1%
4iUeTCbgS85/LHCudzqRUY9K7uZUaV+XmTLjIYUF23I=	1	0.1%
2+xPFcvkGfuCT8qR0zgaokU5UZCNYMgNb81CNU/P9Go=	1	0.1%
JpWaI65ySCqcBU8OPLZzhthGVmXDl0ELqJmy7U92MHg=	1	0.1%
sJwXclAfmrjPjVl/cqyVKVP7kjERclaUtbs/dhr2Obs=	1	0.1%
DymODQGTZFEJXnF0hn2SuGTYNrSVGvqwFP+K1sGW6og=	1	0.1%
Ws4XrZKX0bs08dB7pJfDGChW3wY4jf3UMbOmtxsy3/U=	1	0.1%
LnieTLWsIZjnIVzWh0pY9hAmN1JmX7IZB+rbBsTk+y8=	1	0.1%
U6+yJJmRLW0bcsNAQ4Iq5bK9kQppsAG55FF3Tvq0dXk=	1	0.1%
9P1MuH3mqyH3Sd6+lJVmqjQxIITaFwN4bWMkg+QYFFQ=	1	0.1%
Other values (1610)	1610	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
w8s1ozwdzvuglhpzrssmffbenilgowuli7ngy9fcq44	1	0.1%
4iuetcbgs85/lhcudzqruy9k7uzuav+xmtljiyuf23i	1	0.1%
2+xpfcvkgfuct8qr0zgaoku5uzcnymgnb81cnu/p9go	1	0.1%
jpwai65yscqcbu8oplzzhthgvmxdl0elqjmy7u92mhg	1	0.1%
sjwxclafmrjpjvl/cqyvkvp7kjerclautbs/dhr2obs	1	0.1%
dymodqgtzfejxnf0hn2sugtynrsvgvqwfp+k1sgw6og	1	0.1%
ws4xrzkx0bs08db7pjfdgchw3wy4jf3umbomtxsy3/u	1	0.1%
lnietlwsizjnivzwh0py9hamn1jmx7izb+rbbstk+y8	1	0.1%
u6+yjjmrlw0bcsnaq4iq5bk9kqppsag55ff3tvq0dxk	1	0.1%
9p1muh3mqyh3sd6+ljvmqjqxiitafwn4bwmkg+qyffq	1	0.1%
Other values (1610)	1610	99.4%

Most occurring characters

Value	Count	Frequency (%)
=	1620	2.3%
8	1216	1.7%
c	1215	1.7%
o	1197	1.7%
I	1182	1.7%
M	1181	1.7%
0	1181	1.7%
s	1164	1.6%
g	1158	1.6%
A	1158	1.6%
Other values (55)	59008	82.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	28452	39.9%
Uppercase Letter	28227	39.6%
Decimal Number	10747	15.1%
Math Symbol	2759	3.9%
Other Punctuation	1095	1.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	1215	4.3%
o	1197	4.2%
s	1164	4.1%
g	1158	4.1%
w	1157	4.1%
k	1155	4.1%
b	1112	3.9%
j	1110	3.9%
r	1103	3.9%
i	1101	3.9%
Other values (16)	16980	59.7%

Uppercase Letter

Value	Count	Frequency (%)
I	1182	4.2%
M	1181	4.2%
A	1158	4.1%
Q	1152	4.1%
E	1145	4.1%
Y	1139	4.0%
U	1136	4.0%
L	1132	4.0%
T	1114	3.9%
R	1111	3.9%
Other values (16)	16777	59.4%

Decimal Number

Value	Count	Frequency (%)
8	1216	11.3%
0	1181	11.0%
4	1128	10.5%
9	1059	9.9%
3	1052	9.8%
1	1036	9.6%
7	1032	9.6%
6	1029	9.6%
2	1011	9.4%
5	1003	9.3%

Math Symbol

Value	Count	Frequency (%)
=	1620	58.7%
+	1139	41.3%

Other Punctuation

Value	Count	Frequency (%)
/	1095	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	56679	79.5%
Common	14601	20.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	1215	2.1%
o	1197	2.1%
I	1182	2.1%
M	1181	2.1%
s	1164	2.1%
g	1158	2.0%
A	1158	2.0%
w	1157	2.0%
k	1155	2.0%
Q	1152	2.0%
Other values (42)	44960	79.3%

Common

Value	Count	Frequency (%)
=	1620	11.1%
8	1216	8.3%
0	1181	8.1%
+	1139	7.8%
4	1128	7.7%
/	1095	7.5%
9	1059	7.3%
3	1052	7.2%
1	1036	7.1%
7	1032	7.1%
Other values (3)	3043	20.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	71280	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
=	1620	2.3%
8	1216	1.7%
c	1215	1.7%
o	1197	1.7%
I	1182	1.7%
M	1181	1.7%
0	1181	1.7%
s	1164	1.6%
g	1158	1.6%
A	1158	1.6%
Other values (55)	59008	82.8%

city
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	20
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.359876543

Minimum	1
Maximum	22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	5
95-th percentile	18
Maximum	22
Range	21
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	5.857120697
Coefficient of variation (CV)	1.343414347
Kurtosis	1.761705001
Mean	4.359876543
Median Absolute Deviation (MAD)	0
Skewness	1.70404063
Sum	7063
Variance	34.30586286
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=20)

Value	Count	Frequency (%)
1	1079	66.6%
13	101	6.2%
5	100	6.2%
4	61	3.8%
22	60	3.7%
15	47	2.9%
6	37	2.3%
14	27	1.7%
9	15	0.9%
8	14	0.9%
Other values (10)	79	4.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1079	66.6%
3	7	0.4%
4	61	3.8%
5	100	6.2%
6	37	2.3%
7	4	0.2%
8	14	0.9%
9	15	0.9%
10	12	0.7%
11	12	0.7%

Value	Count	Frequency (%)
22	60	3.7%
21	13	0.8%
20	1	0.1%
18	12	0.7%
17	5	0.3%
16	1	0.1%
15	47	2.9%
14	27	1.7%
13	101	6.2%
12	12	0.7%

bd
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	44
Distinct (%)	2.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.7604321

Minimum	6.3
Maximum	59
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	6.3
5-th percentile	6.3
Q1	6.3
median	6.3
Q3	20
95-th percentile	35
Maximum	59
Range	52.7
Interquartile range (IQR)	13.7

Descriptive statistics

Standard deviation	10.77819768
Coefficient of variation (CV)	0.8446577354
Kurtosis	1.574506315
Mean	12.7604321
Median Absolute Deviation (MAD)	0
Skewness	1.546727874
Sum	20671.9
Variance	116.1695452
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
6.3	1123	69.3%
20	44	2.7%
22	36	2.2%
25	30	1.9%
23	30	1.9%
27	27	1.7%
24	27	1.7%
26	26	1.6%
21	25	1.5%
18	22	1.4%
Other values (34)	230	14.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
6.3	1123	69.3%
14	2	0.1%
15	2	0.1%
16	5	0.3%
17	13	0.8%
18	22	1.4%
19	21	1.3%
20	44	2.7%
21	25	1.5%
22	36	2.2%

Value	Count	Frequency (%)
59	1	0.1%
57	1	0.1%
56	1	0.1%
53	2	0.1%
52	2	0.1%
51	3	0.2%
50	1	0.1%
49	2	0.1%
48	4	0.2%
47	4	0.2%

gender
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

2	1113
0	268
1	239

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	2
4th row	2
5th row	2

Common Values

Value	Count	Frequency (%)
2	1113	68.7%
0	268	16.5%
1	239	14.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
2	1113	68.7%
0	268	16.5%
1	239	14.8%

Most occurring characters

Value	Count	Frequency (%)
2	1113	68.7%
0	268	16.5%
1	239	14.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	1113	68.7%
0	268	16.5%
1	239	14.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	1113	68.7%
0	268	16.5%
1	239	14.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	1113	68.7%
0	268	16.5%
1	239	14.8%

registered_via
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

7	1051
4	225
9	200
3	130
13	14

Length

Max length	2
Median length	1
Mean length	1.008641975
Min length	1

Characters and Unicode

Total characters	1634
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	7
4th row	7
5th row	7

Common Values

Value	Count	Frequency (%)
7	1051	64.9%
4	225	13.9%
9	200	12.3%
3	130	8.0%
13	14	0.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
7	1051	64.9%
4	225	13.9%
9	200	12.3%
3	130	8.0%
13	14	0.9%

Most occurring characters

Value	Count	Frequency (%)
7	1051	64.3%
4	225	13.8%
9	200	12.2%
3	144	8.8%
1	14	0.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1634	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
7	1051	64.3%
4	225	13.8%
9	200	12.2%
3	144	8.8%
1	14	0.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	1634	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
7	1051	64.3%
4	225	13.8%
9	200	12.2%
3	144	8.8%
1	14	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1634	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
7	1051	64.3%
4	225	13.8%
9	200	12.2%
3	144	8.8%
1	14	0.9%

registration_init_time
Date

Distinct	636
Distinct (%)	39.3%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

Minimum	2015-01-01 00:00:00
Maximum	2017-01-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

is_churn
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

0	1508
1	112

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1508	93.1%
1	112	6.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	1508	93.1%
1	112	6.9%

Most occurring characters

Value	Count	Frequency (%)
0	1508	93.1%
1	112	6.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1508	93.1%
1	112	6.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1508	93.1%
1	112	6.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1508	93.1%
1	112	6.9%

total_payment_channels
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.9308642

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	7
median	12
Q3	17
95-th percentile	23
Maximum	31
Range	30
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.306376705
Coefficient of variation (CV)	0.5285766899
Kurtosis	-0.7384112912
Mean	11.9308642
Median Absolute Deviation (MAD)	5
Skewness	0.2471306309
Sum	19328
Variance	39.77038715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
9	106	6.5%
8	97	6.0%
14	88	5.4%
17	88	5.4%
13	86	5.3%
16	85	5.2%
15	83	5.1%
7	83	5.1%
3	79	4.9%
5	74	4.6%
Other values (21)	751	46.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12	0.7%
2	73	4.5%
3	79	4.9%
4	70	4.3%
5	74	4.6%
6	69	4.3%
7	83	5.1%
8	97	6.0%
9	106	6.5%
10	67	4.1%

Value	Count	Frequency (%)
31	1	0.1%
30	1	0.1%
29	2	0.1%
28	1	0.1%
27	6	0.4%
26	16	1.0%
25	16	1.0%
24	31	1.9%
23	21	1.3%
22	18	1.1%

change_in_payment_methods
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

1	1428
2	160
3	28
4	3
5	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	2
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1428	88.1%
2	160	9.9%
3	28	1.7%
4	3	0.2%
5	1	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	1428	88.1%
2	160	9.9%
3	28	1.7%
4	3	0.2%
5	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	1428	88.1%
2	160	9.9%
3	28	1.7%
4	3	0.2%
5	1	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1428	88.1%
2	160	9.9%
3	28	1.7%
4	3	0.2%
5	1	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1428	88.1%
2	160	9.9%
3	28	1.7%
4	3	0.2%
5	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1428	88.1%
2	160	9.9%
3	28	1.7%
4	3	0.2%
5	1	0.1%

payment_plan_days_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	142
Distinct (%)	8.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.27200278

Minimum	7
Maximum	410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	7
5-th percentile	28.69268775
Q1	30
median	30
Q3	30
95-th percentile	33.34313725
Maximum	410
Range	403
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	21.00514917
Coefficient of variation (CV)	0.6508783889
Kurtosis	217.8071299
Mean	32.27200278
Median Absolute Deviation (MAD)	0
Skewness	13.61431953
Sum	52280.6445
Variance	441.2162918
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	1372	84.7%
28.75	15	0.9%
28.8	10	0.6%
28.69565217	7	0.4%
26.71428571	5	0.3%
28.63636364	5	0.3%
28.84615385	5	0.3%
29	5	0.3%
45	4	0.2%
37.5	4	0.2%
Other values (132)	188	11.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	1	0.1%
12.66666667	1	0.1%
18.14285714	1	0.1%
18.5	2	0.1%
20.93548387	1	0.1%
22.17391304	2	0.1%
22.33333333	4	0.2%
22.8	1	0.1%
23.18181818	1	0.1%
23.42857143	1	0.1%

Value	Count	Frequency (%)
410	3	0.2%
302.5	1	0.1%
195	2	0.1%
180	1	0.1%
149	2	0.1%
147.5	1	0.1%
135	1	0.1%
132.3333333	1	0.1%
125	1	0.1%
120	2	0.1%

change_in_plan
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

1	1382
2	179
3	53
4	5
5	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	2
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1382	85.3%
2	179	11.0%
3	53	3.3%
4	5	0.3%
5	1	0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	1382	85.3%
2	179	11.0%
3	53	3.3%
4	5	0.3%
5	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	1382	85.3%
2	179	11.0%
3	53	3.3%
4	5	0.3%
5	1	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1382	85.3%
2	179	11.0%
3	53	3.3%
4	5	0.3%
5	1	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1382	85.3%
2	179	11.0%
3	53	3.3%
4	5	0.3%
5	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1382	85.3%
2	179	11.0%
3	53	3.3%
4	5	0.3%
5	1	0.1%

plan_list_price_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	291
Distinct (%)	18.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	133.6361603

Minimum	0
Maximum	1788
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	99
Q1	99
median	112.9381818
Q3	149
95-th percentile	180
Maximum	1788
Range	1788
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	91.18492909
Coefficient of variation (CV)	0.6823372421
Kurtosis	208.4362207
Mean	133.6361603
Median Absolute Deviation (MAD)	13.93818182
Skewness	12.61208068
Sum	216490.5797
Variance	8314.691292
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	740	45.7%
149	333	20.6%
180	89	5.5%
129	26	1.6%
100	19	1.2%
143.04	9	0.6%
142.7916667	9	0.6%
139.6875	7	0.4%
142.5217391	7	0.4%
139	6	0.4%
Other values (281)	375	23.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
24.83333333	1	0.1%
74.5	2	0.1%
77.14285714	1	0.1%
87.96774194	1	0.1%
90	1	0.1%
92.8125	1	0.1%
93.26086957	1	0.1%
99	740	45.7%
99.06666667	1	0.1%

Value	Count	Frequency (%)
1788	3	0.2%
894	2	0.1%
687	1	0.1%
656	1	0.1%
629.3333333	1	0.1%
596	1	0.1%
582	1	0.1%
536	1	0.1%
480	1	0.1%
477	2	0.1%

actual_amount_paid_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	287
Distinct (%)	17.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	133.1996603

Minimum	0
Maximum	1788
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	99
Q1	99
median	111.75
Q3	149
95-th percentile	180
Maximum	1788
Range	1788
Interquartile range (IQR)	50

Descriptive statistics

Standard deviation	91.25875507
Coefficient of variation (CV)	0.685127536
Kurtosis	207.9944239
Mean	133.1996603
Median Absolute Deviation (MAD)	12.75
Skewness	12.59417892
Sum	215783.4497
Variance	8328.160377
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99	741	45.7%
149	356	22.0%
180	87	5.4%
129	28	1.7%
100	19	1.2%
139	8	0.5%
111.75	5	0.3%
140.7222222	5	0.3%
119.2	5	0.3%
135.6666667	4	0.2%
Other values (277)	362	22.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
24.83333333	1	0.1%
70.71428571	1	0.1%
74.5	2	0.1%
77	2	0.1%
77.14285714	1	0.1%
84.85714286	1	0.1%
86.625	1	0.1%
87.35294118	1	0.1%
87.41176471	1	0.1%

Value	Count	Frequency (%)
1788	3	0.2%
894	2	0.1%
687	1	0.1%
656	1	0.1%
629.3333333	1	0.1%
596	1	0.1%
582	1	0.1%
536	1	0.1%
480	1	0.1%
477	2	0.1%

is_auto_renew_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	62
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.8272474253

Minimum	0
Maximum	1
Zeros	237
Zeros (%)	14.6%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	1
95-th percentile	1
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.3601876146
Coefficient of variation (CV)	0.4354049388
Kurtosis	1.22819203
Mean	0.8272474253
Median Absolute Deviation (MAD)	0
Skewness	-1.757435963
Sum	1340.140829
Variance	0.1297351177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1255	77.5%
0	237	14.6%
0.75	9	0.6%
0.8	7	0.4%
0.6666666667	7	0.4%
0.5	7	0.4%
0.8571428571	6	0.4%
0.8333333333	6	0.4%
0.4285714286	4	0.2%
0.875	4	0.2%
Other values (52)	78	4.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	237	14.6%
0.1	1	0.1%
0.1333333333	1	0.1%
0.1363636364	1	0.1%
0.1538461538	1	0.1%
0.1818181818	1	0.1%
0.2	1	0.1%
0.2142857143	1	0.1%
0.2222222222	1	0.1%
0.25	2	0.1%

Value	Count	Frequency (%)
1	1255	77.5%
0.9583333333	3	0.2%
0.9545454545	1	0.1%
0.9523809524	1	0.1%
0.9444444444	3	0.2%
0.9375	3	0.2%
0.9333333333	1	0.1%
0.9285714286	1	0.1%
0.9230769231	1	0.1%
0.92	1	0.1%

is_autorenew_change_flag
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

1	1383
0	237

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1383	85.4%
0	237	14.6%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1	1383	85.4%
0	237	14.6%

Most occurring characters

Value	Count	Frequency (%)
1	1383	85.4%
0	237	14.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1383	85.4%
0	237	14.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1383	85.4%
0	237	14.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1383	85.4%
0	237	14.6%

transaction_date_min
Date

Distinct	632
Distinct (%)	39.0%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

Minimum	2015-01-01 00:00:00
Maximum	2017-01-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

transaction_date_max
Date

HIGH CORRELATION

Distinct	85
Distinct (%)	5.2%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

Minimum	2015-12-15 00:00:00
Maximum	2017-02-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

total_transactions
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.9308642

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	7
median	12
Q3	17
95-th percentile	23
Maximum	31
Range	30
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	6.306376705
Coefficient of variation (CV)	0.5285766899
Kurtosis	-0.7384112912
Mean	11.9308642
Median Absolute Deviation (MAD)	5
Skewness	0.2471306309
Sum	19328
Variance	39.77038715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
9	106	6.5%
8	97	6.0%
14	88	5.4%
17	88	5.4%
13	86	5.3%
16	85	5.2%
15	83	5.1%
7	83	5.1%
3	79	4.9%
5	74	4.6%
Other values (21)	751	46.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	12	0.7%
2	73	4.5%
3	79	4.9%
4	70	4.3%
5	74	4.6%
6	69	4.3%
7	83	5.1%
8	97	6.0%
9	106	6.5%
10	67	4.1%

Value	Count	Frequency (%)
31	1	0.1%
30	1	0.1%
29	2	0.1%
28	1	0.1%
27	6	0.4%
26	16	1.0%
25	16	1.0%
24	31	1.9%
23	21	1.3%
22	18	1.1%

membership_expire_date_max
Date

HIGH CORRELATION

Distinct	59
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

Minimum	2017-02-01 00:00:00
Maximum	2017-03-31 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

is_cancel_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	37
Distinct (%)	2.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.01248799314

Minimum	0
Maximum	0.5
Zeros	1395
Zeros (%)	86.1%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.08333333333
Maximum	0.5
Range	0.5
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.03930297574
Coefficient of variation (CV)	3.147261157
Kurtosis	43.16468295
Mean	0.01248799314
Median Absolute Deviation (MAD)	0
Skewness	5.353976071
Sum	20.23054889
Variance	0.001544723902
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
0	1395	86.1%
0.07142857143	20	1.2%
0.05555555556	17	1.0%
0.0625	15	0.9%
0.1	14	0.9%
0.09090909091	12	0.7%
0.07692307692	12	0.7%
0.05263157895	12	0.7%
0.06666666667	11	0.7%
0.125	10	0.6%
Other values (27)	102	6.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1395	86.1%
0.03703703704	1	0.1%
0.03846153846	3	0.2%
0.04	7	0.4%
0.04166666667	7	0.4%
0.04347826087	4	0.2%
0.04545454545	4	0.2%
0.04761904762	8	0.5%
0.05	8	0.5%
0.05263157895	12	0.7%

Value	Count	Frequency (%)
0.5	2	0.1%
0.3333333333	3	0.2%
0.2857142857	1	0.1%
0.25	3	0.2%
0.2142857143	1	0.1%
0.2	3	0.2%
0.1818181818	2	0.1%
0.1724137931	1	0.1%
0.1666666667	5	0.3%
0.1538461538	1	0.1%

is_cancel_change_flag
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

0	1395
1	225

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
0	1395	86.1%
1	225	13.9%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	1395	86.1%
1	225	13.9%

Most occurring characters

Value	Count	Frequency (%)
0	1395	86.1%
1	225	13.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1395	86.1%
1	225	13.9%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1395	86.1%
1	225	13.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1395	86.1%
1	225	13.9%

discount_mean
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	80
Distinct (%)	4.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.436500008

Minimum	-38.86956522
Maximum	90
Zeros	1438
Zeros (%)	88.8%
Negative	91
Negative (%)	5.6%
Memory size	12.8 KiB

Quantile statistics

Minimum	-38.86956522
5-th percentile	-5.382175926
Q1	0
median	0
Q3	0
95-th percentile	5.730769231
Maximum	90
Range	128.8695652
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	5.801866399
Coefficient of variation (CV)	13.2917899
Kurtosis	60.03643088
Mean	0.436500008
Median Absolute Deviation (MAD)	0
Skewness	4.665131468
Sum	707.1300129
Variance	33.66165371
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1438	88.8%
-6.208333333	11	0.7%
-5.96	10	0.6%
-5.730769231	7	0.4%
14.9	6	0.4%
-5.375	6	0.4%
-6.47826087	5	0.3%
8.277777778	5	0.3%
18.625	5	0.3%
16.55555556	4	0.2%
Other values (70)	123	7.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-38.86956522	2	0.1%
-35.76	1	0.1%
-32.95454545	1	0.1%
-27.59259259	1	0.1%
-24.83333333	1	0.1%
-22.35	1	0.1%
-18.625	1	0.1%
-15.68421053	1	0.1%
-13.54545455	2	0.1%
-12.41666667	1	0.1%

Value	Count	Frequency (%)
90	1	0.1%
60	1	0.1%
50	1	0.1%
42.57142857	2	0.1%
37.25	3	0.2%
33.11111111	3	0.2%
31.92857143	1	0.1%
29.8	4	0.2%
27.09090909	1	0.1%
24.83333333	1	0.1%

is_discount_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	46
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.008801214038

Minimum	0
Maximum	1
Zeros	1520
Zeros (%)	93.8%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0.04773809524
Maximum	1
Range	1
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.04973378859
Coefficient of variation (CV)	5.650787309
Kurtosis	144.2724941
Mean	0.008801214038
Median Absolute Deviation (MAD)	0
Skewness	10.17689583
Sum	14.25796674
Variance	0.002473449728
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
0	1520	93.8%
0.04347826087	6	0.4%
0.1	6	0.4%
0.125	5	0.3%
0.05555555556	5	0.3%
0.1111111111	4	0.2%
0.09090909091	4	0.2%
0.2	4	0.2%
0.25	4	0.2%
0.05263157895	4	0.2%
Other values (36)	58	3.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1520	93.8%
0.03333333333	1	0.1%
0.03703703704	1	0.1%
0.03846153846	4	0.2%
0.04	1	0.1%
0.04166666667	3	0.2%
0.04347826087	6	0.4%
0.04545454545	2	0.1%
0.04761904762	1	0.1%
0.05	3	0.2%

Value	Count	Frequency (%)
1	1	0.1%
0.6363636364	2	0.1%
0.5	1	0.1%
0.4090909091	1	0.1%
0.3636363636	1	0.1%
0.3333333333	1	0.1%
0.3076923077	1	0.1%
0.2916666667	1	0.1%
0.2857142857	2	0.1%
0.28	1	0.1%

is_discount_max
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

0	1520
1	100

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1620
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	1520	93.8%
1	100	6.2%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	1520	93.8%
1	100	6.2%

Most occurring characters

Value	Count	Frequency (%)
0	1520	93.8%
1	100	6.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1620	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	1520	93.8%
1	100	6.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	1620	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	1520	93.8%
1	100	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1620	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1520	93.8%
1	100	6.2%

amt_per_day_mean
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	321
Distinct (%)	19.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.081865522

Minimum	0
Maximum	6
Zeros	1
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	3.3
Q1	3.3
median	3.526573751
Q3	4.966666667
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	1.666666667

Descriptive statistics

Standard deviation	0.9029994755
Coefficient of variation (CV)	0.2212222501
Kurtosis	-0.6878973932
Mean	4.081865522
Median Absolute Deviation (MAD)	0.3801722803
Skewness	0.4313038117
Sum	6612.622146
Variance	0.8154080527
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.3	652	40.2%
4.966666667	296	18.3%
3.3	89	5.5%
6	87	5.4%
4.3	26	1.6%
3.333333333	19	1.2%
4.690740741	7	0.4%
3.973333333	6	0.4%
4.768	6	0.4%
4.759722222	6	0.4%
Other values (311)	426	26.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	0.1%
0.8277777778	1	0.1%
1.503917379	1	0.1%
2.292307692	1	0.1%
2.357142857	1	0.1%
2.483333333	2	0.1%
2.564769648	1	0.1%
2.566666667	2	0.1%
2.571428571	1	0.1%
2.828571429	1	0.1%

Value	Count	Frequency (%)
6	87	5.4%
5.9	2	0.1%
5.890909091	1	0.1%
5.888888889	1	0.1%
5.854761905	1	0.1%
5.850997783	1	0.1%
5.846153846	1	0.1%
5.842735043	1	0.1%
5.833333333	1	0.1%
5.8	3	0.2%

membership_duration_mean
Real number (ℝ)

SKEWED

Distinct	459
Distinct (%)	28.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.31085938

Minimum	-4273.25
Maximum	414
Zeros	0
Zeros (%)	0.0%
Negative	1
Negative (%)	0.1%
Memory size	12.8 KiB

Quantile statistics

Minimum	-4273.25
5-th percentile	27.24903846
Q1	29.98
median	30.3125
Q3	30.42105263
95-th percentile	42.20666667
Maximum	414
Range	4687.25
Interquartile range (IQR)	0.4410526316

Descriptive statistics

Standard deviation	109.042384
Coefficient of variation (CV)	3.597469232
Kurtosis	1501.452087
Mean	30.31085938
Median Absolute Deviation (MAD)	0.2430555556
Skewness	-37.92216912
Sum	49103.5922
Variance	11890.24151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	135	8.3%
30.33333333	83	5.1%
30.375	60	3.7%
30.4	53	3.3%
29	46	2.8%
30.28571429	43	2.7%
30.41176471	36	2.2%
30.30769231	33	2.0%
30.25	33	2.0%
30.42105263	29	1.8%
Other values (449)	1069	66.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-4273.25	1	0.1%
7	1	0.1%
12.375	1	0.1%
15	1	0.1%
16.5	1	0.1%
17.25	1	0.1%
17.5	1	0.1%
18	2	0.1%
18.33333333	1	0.1%
18.5	1	0.1%

Value	Count	Frequency (%)
414	1	0.1%
413	1	0.1%
411	1	0.1%
197.6666667	1	0.1%
196.5	1	0.1%
195	1	0.1%
189	1	0.1%
180	1	0.1%
150.3333333	1	0.1%
147.3333333	1	0.1%

more_than_30_sum
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	24
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.716049383

Minimum	0
Maximum	30
Zeros	210
Zeros (%)	13.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	5
Q3	9
95-th percentile	13
Maximum	30
Range	30
Interquartile range (IQR)	7

Descriptive statistics

Standard deviation	4.297850039
Coefficient of variation (CV)	0.7518916915
Kurtosis	0.2541138802
Mean	5.716049383
Median Absolute Deviation (MAD)	4
Skewness	0.5507513391
Sum	9260
Variance	18.47151496
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	210	13.0%
1	152	9.4%
5	137	8.5%
9	133	8.2%
7	132	8.1%
2	123	7.6%
10	117	7.2%
6	108	6.7%
4	101	6.2%
3	98	6.0%
Other values (14)	309	19.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	210	13.0%
1	152	9.4%
2	123	7.6%
3	98	6.0%
4	101	6.2%
5	137	8.5%
6	108	6.7%
7	132	8.1%
8	91	5.6%
9	133	8.2%

Value	Count	Frequency (%)
30	1	0.1%
26	1	0.1%
21	1	0.1%
20	1	0.1%
19	2	0.1%
18	9	0.6%
17	2	0.1%
16	6	0.4%
15	5	0.3%
14	35	2.2%

num_25
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1290
Distinct (%)	79.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.079500914

Minimum	0
Maximum	5.003946304
Zeros	70
Zeros (%)	4.3%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.1149469078
Q1	0.5556846708
median	0.9921378791
Q3	1.484854251
95-th percentile	2.387628365
Maximum	5.003946304
Range	5.003946304
Interquartile range (IQR)	0.9291695803

Descriptive statistics

Standard deviation	0.7032536268
Coefficient of variation (CV)	0.6514618397
Kurtosis	1.182220221
Mean	1.079500914
Median Absolute Deviation (MAD)	0.4566862583
Skewness	0.8732081056
Sum	1748.791504
Variance	0.4945656955
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	70	4.3%
0.1732867956	28	1.7%
0.3465735912	22	1.4%
0.2746530771	15	0.9%
0.4023594856	13	0.8%
0.4479398727	12	0.7%
0.6931471825	10	0.6%
0.794513464	9	0.6%
0.6212266684	9	0.6%
0.2310490608	8	0.5%
Other values (1280)	1424	87.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	70	4.3%
0.05776226521	2	0.1%
0.07701635361	1	0.1%
0.08664339781	5	0.3%
0.09155102819	1	0.1%
0.1005898714	1	0.1%
0.1039720774	1	0.1%
0.1155245304	5	0.3%
0.1204321608	1	0.1%
0.121471338	1	0.1%

Value	Count	Frequency (%)
5.003946304	1	0.1%
4.140595436	1	0.1%
3.867604733	1	0.1%
3.812770605	1	0.1%
3.771541119	1	0.1%
3.736549139	1	0.1%
3.527849913	1	0.1%
3.522888184	1	0.1%
3.456262112	1	0.1%
3.423892498	1	0.1%

num_50
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	823
Distinct (%)	50.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3590388298

Minimum	0
Maximum	2.708050251
Zeros	265
Zeros (%)	16.4%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.1155245304
median	0.2746530771
Q3	0.5198603868
95-th percentile	1.047928405
Maximum	2.708050251
Range	2.708050251
Interquartile range (IQR)	0.4043358564

Descriptive statistics

Standard deviation	0.3483375907
Coefficient of variation (CV)	0.970194757
Kurtosis	4.850337982
Mean	0.3590388298
Median Absolute Deviation (MAD)	0.1880096793
Skewness	1.749609113
Sum	581.6428833
Variance	0.1213390753
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	265	16.4%
0.1732867956	81	5.0%
0.08664339781	33	2.0%
0.3465735912	30	1.9%
0.1155245304	22	1.4%
0.2310490608	21	1.3%
0.2746530771	19	1.2%
0.05776226521	18	1.1%
0.5198603868	13	0.8%
0.4479398727	12	0.7%
Other values (813)	1106	68.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	265	16.4%
0.02475525625	3	0.2%
0.02746530809	1	0.1%
0.0288811326	3	0.2%
0.03465735912	5	0.3%
0.0385081768	1	0.1%
0.0433216989	4	0.2%
0.0457755141	2	0.1%
0.04620981216	1	0.1%
0.04726003483	1	0.1%

Value	Count	Frequency (%)
2.708050251	1	0.1%
2.397895336	1	0.1%
2.237657309	1	0.1%
2.215408325	1	0.1%
2.138333082	1	0.1%
2.079441547	1	0.1%
2.050125837	1	0.1%
1.88765347	1	0.1%
1.821205258	1	0.1%
1.818099618	1	0.1%

num_75
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	601
Distinct (%)	37.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2241915166

Minimum	0
Maximum	2.564949274
Zeros	410
Zeros (%)	25.3%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.1732867956
Q3	0.3157505095
95-th percentile	0.6932374895
Maximum	2.564949274
Range	2.564949274
Interquartile range (IQR)	0.3157505095

Descriptive statistics

Standard deviation	0.2568334043
Coefficient of variation (CV)	1.145598173
Kurtosis	10.52245426
Mean	0.2241915166
Median Absolute Deviation (MAD)	0.1490656137
Skewness	2.406011105
Sum	363.1902466
Variance	0.06596340239
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	410	25.3%
0.1732867956	77	4.8%
0.08664339781	46	2.8%
0.1155245304	38	2.3%
0.05776226521	29	1.8%
0.3465735912	27	1.7%
0.2746530771	25	1.5%
0.2310490608	25	1.5%
0.09155102819	14	0.9%
0.1386294365	13	0.8%
Other values (591)	916	56.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	410	25.3%
0.0144405663	1	0.1%
0.0192540884	1	0.1%
0.02166084945	1	0.1%
0.02475525625	5	0.3%
0.0288811326	10	0.6%
0.03465735912	9	0.6%
0.0385081768	3	0.2%
0.03923615441	1	0.1%
0.0433216989	11	0.7%

Value	Count	Frequency (%)
2.564949274	1	0.1%
2.302585125	1	0.1%
1.766829133	1	0.1%
1.763180256	1	0.1%
1.465654254	1	0.1%
1.386294365	2	0.1%
1.370159745	1	0.1%
1.305276513	1	0.1%
1.297273517	1	0.1%
1.292621017	1	0.1%

num_985
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	607
Distinct (%)	37.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2246976197

Minimum	0
Maximum	2.079441547
Zeros	405
Zeros (%)	25.0%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.01083042473
median	0.1732867956
Q3	0.3226000965
95-th percentile	0.7324753463
Maximum	2.079441547
Range	2.079441547
Interquartile range (IQR)	0.3117696717

Descriptive statistics

Standard deviation	0.2528685033
Coefficient of variation (CV)	1.12537241
Kurtosis	5.4888978
Mean	0.2246976197
Median Absolute Deviation (MAD)	0.1493133008
Skewness	1.953810692
Sum	364.0101318
Variance	0.06394248456
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	405	25.0%
0.1732867956	87	5.4%
0.08664339781	42	2.6%
0.05776226521	35	2.2%
0.2310490608	29	1.8%
0.1155245304	26	1.6%
0.2746530771	24	1.5%
0.3465735912	23	1.4%
0.2239699364	18	1.1%
0.4479398727	15	0.9%
Other values (597)	916	56.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	405	25.0%
0.0144405663	1	0.1%
0.02166084945	1	0.1%
0.02475525625	3	0.2%
0.0288811326	5	0.3%
0.03300700709	2	0.1%
0.03465735912	11	0.7%
0.0385081768	3	0.2%
0.03923615441	2	0.1%
0.04072180763	1	0.1%

Value	Count	Frequency (%)
2.079441547	1	0.1%
1.784716845	1	0.1%
1.42594564	1	0.1%
1.386294365	1	0.1%
1.360248685	1	0.1%
1.319528699	1	0.1%
1.316468716	1	0.1%
1.31267333	1	0.1%
1.298239231	1	0.1%
1.283491373	1	0.1%

num_100
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1553
Distinct (%)	95.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.400013208

Minimum	0
Maximum	5.924189091
Zeros	22
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0.8953939259
Q1	1.886082977
median	2.418399572
Q3	2.946542084
95-th percentile	3.805382395
Maximum	5.924189091
Range	5.924189091
Interquartile range (IQR)	1.060459107

Descriptive statistics

Standard deviation	0.8693374395
Coefficient of variation (CV)	0.3622219265
Kurtosis	0.5379921794
Mean	2.400013208
Median Absolute Deviation (MAD)	0.5311615467
Skewness	-0.05542365834
Sum	3888.021484
Variance	0.7557476163
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	22	1.4%
0.6931471825	6	0.4%
0.7225929499	3	0.2%
1.471526027	3	0.2%
1.555644035	3	0.2%
0.8958797455	3	0.2%
0.8664339781	3	0.2%
0.2746530771	3	0.2%
1.023586154	2	0.1%
0.5198603868	2	0.1%
Other values (1543)	1570	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	22	1.4%
0.2310490608	1	0.1%
0.2746530771	3	0.2%
0.3080654144	1	0.1%
0.3465735912	1	0.1%
0.3662041128	2	0.1%
0.4023594856	1	0.1%
0.4305278957	1	0.1%
0.4479398727	2	0.1%
0.4864775538	2	0.1%

Value	Count	Frequency (%)
5.924189091	1	0.1%
5.481370449	1	0.1%
5.224838734	1	0.1%
5.098548412	1	0.1%
4.954596043	1	0.1%
4.903764725	1	0.1%
4.890113831	1	0.1%
4.885931015	1	0.1%
4.880422115	1	0.1%
4.84425354	1	0.1%

num_unq
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1579
Distinct (%)	97.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.621389151

Minimum	0
Maximum	5.257495403
Zeros	5
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	6.5 KiB

Quantile statistics

Minimum	0
5-th percentile	1.314168793
Q1	2.181361258
median	2.659072638
Q3	3.083636224
95-th percentile	3.811152709
Maximum	5.257495403
Range	5.257495403
Interquartile range (IQR)	0.9022749662

Descriptive statistics

Standard deviation	0.7503094673
Coefficient of variation (CV)	0.2862258852
Kurtosis	0.6455993056
Mean	2.621389151
Median Absolute Deviation (MAD)	0.4508309364
Skewness	-0.2068370581
Sum	4246.650391
Variance	0.5629643202
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.6931471825	7	0.4%
0	5	0.3%
2.059369802	4	0.2%
1.098612309	3	0.2%
0.8958797455	3	0.2%
1.818099618	3	0.2%
0.5972531438	3	0.2%
1.059351325	3	0.2%
1.370159745	2	0.1%
0.7489330769	2	0.1%
Other values (1569)	1585	97.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5	0.3%
0.1732867956	1	0.1%
0.3465735912	2	0.1%
0.5493061543	2	0.1%
0.5972531438	3	0.2%
0.6212266684	1	0.1%
0.6770125628	1	0.1%
0.6931471825	7	0.4%
0.7489330769	2	0.1%
0.7739418149	1	0.1%

Value	Count	Frequency (%)
5.257495403	1	0.1%
4.943751335	1	0.1%
4.847590446	1	0.1%
4.794824123	1	0.1%
4.755366325	1	0.1%
4.738386631	1	0.1%
4.723978043	1	0.1%
4.69779253	1	0.1%
4.625041008	1	0.1%
4.53429842	1	0.1%

total_secs
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	583
Distinct (%)	36.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.0078125

Minimum	0.9223632812
Maximum	10.890625
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.3 KiB

Quantile statistics

Minimum	0.9223632812
5-th percentile	6.464453125
Q1	7.549804688
median	8.0625
Q3	8.5625
95-th percentile	9.351953125
Maximum	10.890625
Range	9.968261719
Interquartile range (IQR)	1.012695312

Descriptive statistics

Standard deviation	0.9106445312
Coefficient of variation (CV)	0.1137084961
Kurtosis	4.74609375
Mean	8.0078125
Median Absolute Deviation (MAD)	0.5078125
Skewness	-1.012695312
Sum	12976
Variance	0.8291015625
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8.0703125	11	0.7%
8.125	11	0.7%
8.109375	10	0.6%
8.265625	10	0.6%
8.2109375	10	0.6%
8.03125	10	0.6%
8.1640625	10	0.6%
8.3515625	9	0.6%
8.234375	9	0.6%
8.5	9	0.6%
Other values (573)	1521	93.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.9223632812	1	0.1%
2.8984375	1	0.1%
3.55078125	1	0.1%
3.6953125	1	0.1%
3.70703125	1	0.1%
3.7421875	1	0.1%
3.77734375	1	0.1%
3.99609375	1	0.1%
4.4375	1	0.1%
4.625	1	0.1%

Value	Count	Frequency (%)
10.890625	1	0.1%
10.6328125	1	0.1%
10.6015625	1	0.1%
10.4375	1	0.1%
10.421875	1	0.1%
10.40625	1	0.1%
10.375	1	0.1%
10.328125	1	0.1%
10.203125	1	0.1%
10.1875	1	0.1%

login_freq
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	49
Distinct (%)	3.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.08271605

Minimum	1
Maximum	60
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	4
median	12
Q3	21
95-th percentile	39
Maximum	60
Range	59
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	11.50644785
Coefficient of variation (CV)	0.7628896424
Kurtosis	0.4466703241
Mean	15.08271605
Median Absolute Deviation (MAD)	8
Skewness	1.024195927
Sum	24434
Variance	132.3983422
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
4	298	18.4%
12	190	11.7%
8	177	10.9%
20	110	6.8%
16	106	6.5%
24	93	5.7%
28	73	4.5%
3	70	4.3%
32	54	3.3%
6	49	3.0%
Other values (39)	400	24.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	23	1.4%
2	24	1.5%
3	70	4.3%
4	298	18.4%
5	15	0.9%
6	49	3.0%
7	5	0.3%
8	177	10.9%
9	32	2.0%
10	9	0.6%

Value	Count	Frequency (%)
60	1	0.1%
56	1	0.1%
52	9	0.6%
48	13	0.8%
46	2	0.1%
45	2	0.1%
44	23	1.4%
43	1	0.1%
42	1	0.1%
41	1	0.1%

last_login
Date

Distinct	275
Distinct (%)	17.0%
Missing	0
Missing (%)	0.0%
Memory size	12.8 KiB

Minimum	2015-02-27 00:00:00
Maximum	2017-02-28 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

registration_duration
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	454
Distinct (%)	28.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	403.6481481

Minimum	14
Maximum	809
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.8 KiB

Quantile statistics

Minimum	14
5-th percentile	89
Q1	243
median	408.5
Q3	547
95-th percentile	745
Maximum	809
Range	795
Interquartile range (IQR)	304

Descriptive statistics

Standard deviation	195.3883345
Coefficient of variation (CV)	0.4840560657
Kurtosis	-0.8639791412
Mean	403.6481481
Median Absolute Deviation (MAD)	151
Skewness	0.0512464614
Sum	653910
Variance	38176.60126
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
517	42	2.6%
394	35	2.2%
578	33	2.0%
393	31	1.9%
609	31	1.9%
272	30	1.9%
242	29	1.8%
89	29	1.8%
425	28	1.7%
455	28	1.7%
Other values (444)	1304	80.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
14	1	0.1%
30	1	0.1%
34	1	0.1%
35	1	0.1%
36	1	0.1%
52	1	0.1%
58	20	1.2%
59	5	0.3%
60	1	0.1%
61	4	0.2%

Value	Count	Frequency (%)
809	1	0.1%
807	1	0.1%
805	1	0.1%
801	2	0.1%
799	1	0.1%
798	2	0.1%
797	2	0.1%
796	1	0.1%
795	1	0.1%
793	3	0.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	msno	city	bd	gender	registered_via	registration_init_time	is_churn	total_payment_channels	change_in_payment_methods	payment_plan_days_mean	change_in_plan	plan_list_price_mean	actual_amount_paid_mean	is_auto_renew_mean	is_autorenew_change_flag	transaction_date_min	transaction_date_max	total_transactions	membership_expire_date_max	is_cancel_mean	is_cancel_change_flag	amt_per_day_mean	membership_duration_mean	more_than_30_sum	num_25	num_50	num_75	num_985	num_100	num_unq	total_secs	login_freq	last_login	registration_duration
0	97370	w8s1oZwdZVugLhPzRsSmfFBeniLGowuLi7NgY9FCq44=	13	6.3	0	4	2016-01-30	1	2	2	18.500000	2	90.000000	90.000000	0.0	0	2016-11-16	2017-01-15	2	2017-02-14	0.000000	0	3.000000	18.500000	0	0.173287	0.000000	0.000000	0.000000	3.299368	3.353329	8.929688	4	2017-02-11	381
1	100926	cnncNsMOZE3kiTKQNSBbVCJMdE+PKr56pBYYeHWJ8Zk=	6	30.0	0	4	2016-02-06	0	13	1	30.000000	1	149.000000	149.000000	1.0	1	2016-02-12	2017-02-12	13	2017-03-11	0.000000	0	4.966667	29.307692	0	0.183102	0.000000	0.000000	0.000000	3.335215	3.347396	8.757812	6	2016-10-05	399
2	66560	aWZDoNfiZtG0IWeC0++ocJXLZORBwDvkYA2rCBA4yAs=	1	6.3	2	7	2015-12-20	0	15	1	30.000000	1	99.000000	99.000000	1.0	1	2015-12-20	2017-02-20	15	2017-03-20	0.000000	0	3.300000	30.400000	9	2.294816	0.613535	0.458858	0.314609	2.776971	3.125320	8.390625	36	2017-02-28	456
3	316477	Ph7IvMxuu+1hJp8qYOAy5llX7D97espKsmhEgicBKls=	1	6.3	2	7	2015-10-04	0	19	1	30.000000	1	123.210526	123.210526	1.0	1	2015-10-04	2017-02-24	19	2017-03-24	0.052632	1	4.107018	28.789474	10	1.465636	0.636444	0.528273	0.531189	2.770634	3.016627	8.390625	28	2017-01-04	537
4	293127	cdrXUooJ9G1gXiLFd5NWqQ5HpgmNzl0aeaojPBJ203k=	1	6.3	2	7	2016-01-31	0	9	1	30.000000	1	99.000000	99.000000	1.0	1	2016-01-31	2017-02-28	9	2017-03-31	0.000000	0	3.300000	30.222222	5	2.385141	1.377237	1.175102	1.134550	1.969944	3.076042	8.007812	28	2017-02-26	425
5	23642	fa9aoepY5IaSL3fZW92105ar3bmT6kea69Qg+7osIfM=	5	24.0	0	7	2015-04-23	0	24	1	30.000000	1	139.000000	139.000000	1.0	1	2015-04-23	2017-02-21	24	2017-03-21	0.041667	1	4.633333	29.125000	13	0.732401	0.173287	0.168567	0.096270	2.597737	2.526508	8.273438	36	2016-12-28	698
6	306400	U03kCv151wiDiVUUAzAQp3IlXuyNQRs47zJxC3FgSy0=	1	6.3	2	9	2015-01-17	0	14	2	26.714286	2	127.714286	127.714286	0.0	0	2015-06-07	2017-01-13	14	2017-02-15	0.000000	0	4.257143	32.142857	5	1.670639	1.216170	1.129197	0.905319	0.308065	2.411968	6.597656	9	2017-02-12	760
7	160211	ELGZ1U3Bcg51pCDH17M5EPQnWkvwnTVktorG+Dks2gE=	11	24.0	1	9	2016-12-07	0	3	1	30.000000	1	149.000000	149.000000	1.0	1	2016-12-11	2017-02-11	3	2017-03-10	0.000000	0	4.966667	29.000000	0	0.173287	0.086643	0.086643	0.086643	2.665609	2.661156	8.242188	8	2017-02-14	93
8	225006	Nv3He2E4qnnPeC1TJulbW84VQouU1S/3Vxuqkhk5Efo=	1	6.3	2	7	2015-07-17	0	20	1	30.000000	1	99.000000	99.000000	1.0	1	2015-07-17	2017-02-16	20	2017-03-16	0.000000	0	3.300000	30.400000	11	1.826880	1.268888	0.366204	0.231049	0.998577	2.531796	7.191406	3	2016-09-26	608
9	195028	YNfyqKWvZ4I8n8uXxQzLr2mSIAoGT1ZFfUrnSH75juU=	1	6.3	2	13	2016-11-20	0	4	1	30.000000	1	100.000000	100.000000	1.0	1	2016-11-20	2017-02-20	4	2017-03-19	0.000000	0	3.333333	29.000000	0	0.767528	0.000000	0.000000	0.000000	1.551320	1.476939	6.660156	3	2016-11-25	119

Last rows

	df_index	msno	city	bd	gender	registered_via	registration_init_time	total_payment_channels	change_in_payment_methods	payment_plan_days_mean	change_in_plan	plan_list_price_mean	actual_amount_paid_mean	is_auto_renew_mean	is_autorenew_change_flag	transaction_date_min	transaction_date_max	total_transactions	membership_expire_date_max	amt_per_day_mean	membership_duration_mean	more_than_30_sum	num_25	num_50	num_75	num_985	num_100	num_unq	total_secs	login_freq	last_login	registration_duration
1610	285559	29MCa0yiHto8ijGxrOwh/V5Zmc8trpCnJ2GGUOKV4cA=	1	6.3	2	7	2015-11-04	16	1	30.0	1	99.0	99.0	1.000000	1	2015-11-04	2017-02-04	16	2017-03-04	3.300000	30.375000	9	0.703060	0.129965	0.143912	0.000000	2.017723	2.238298	7.660156	16	2017-02-20	486
1611	259760	InfWiv47k4qSKgXjv6euBVdz1XKs5lAn2Jq3qgJqGE0=	5	27.0	2	4	2016-09-27	5	2	30.0	1	161.4	161.4	0.600000	1	2016-10-02	2017-02-01	5	2017-03-01	5.380000	30.600000	3	1.329422	0.655878	0.086643	0.173287	3.928295	3.753964	9.515625	8	2017-01-21	155
1612	52984	j6ac4+IFzBBHgOJmbJfRxDSfiw13wqx2lefAHO8D1ig=	1	6.3	2	7	2016-12-17	3	1	30.0	1	99.0	99.0	1.000000	1	2016-12-17	2017-02-16	3	2017-03-16	3.300000	29.666667	1	1.343820	0.000000	0.000000	0.274653	2.374406	2.417573	7.968750	4	2017-01-10	89
1613	138204	03LXJXZDLNp0+7ydhA1FD8/Z/lLeRdEwAqFCrguo/Pc=	1	6.3	2	7	2015-07-26	20	1	30.0	1	99.0	99.0	1.000000	1	2015-07-26	2017-02-26	20	2017-03-26	3.300000	30.450000	12	1.271037	0.385862	0.043322	0.068663	2.580483	1.978765	8.234375	16	2016-12-09	609
1614	247178	lnnbCdp3Hilj8xZHHV74Yw3ZN3TNT859OkNz0EnqCZ8=	12	6.3	2	4	2016-01-16	14	1	30.0	1	149.0	149.0	1.000000	1	2016-01-25	2017-02-25	14	2017-03-24	4.966667	29.357143	0	0.173287	0.000000	0.000000	0.000000	1.527312	1.818100	6.539062	4	2016-03-07	433
1615	289922	sBWL8NR/nkabY7xm5s5Ud8zQ/kiG+0mjPh9QT/UyGz8=	6	22.0	1	7	2016-01-21	14	1	30.0	1	99.0	99.0	1.000000	1	2016-01-21	2017-02-21	14	2017-03-21	3.300000	30.357143	8	1.748862	0.919026	0.423193	0.486732	3.710342	3.578337	9.195312	28	2017-01-15	425
1616	70835	Q5EduhXq7EPKTtuUf4mkgoste1YpSTNetjus1YdqhL0=	1	6.3	2	7	2016-01-14	14	1	30.0	1	99.0	99.0	1.000000	1	2016-01-14	2017-02-14	14	2017-03-14	3.300000	30.357143	8	0.665563	0.598114	0.365941	0.000000	1.696342	2.125916	7.660156	11	2016-07-25	425
1617	37685	n0ghjp6g10QsKB3hGglxB+DRdeCGhsVbFC05o2iTfYk=	1	6.3	2	7	2016-06-05	8	1	30.0	1	99.0	99.0	1.000000	1	2016-06-05	2017-02-05	8	2017-03-05	3.300000	30.250000	4	1.823706	0.538445	0.443589	0.393009	2.163773	2.552268	7.945312	20	2017-02-15	273
1618	139539	l9HJ1oSxg3e3sJ6ycx2J2no7LM25vitw6gGDWPlLfgE=	1	6.3	2	7	2015-11-16	16	1	30.0	1	99.0	99.0	1.000000	1	2015-11-16	2017-02-16	16	2017-03-16	3.300000	30.375000	9	0.524012	0.092420	0.258080	0.046210	1.634552	1.890254	7.070312	15	2017-02-25	486
1619	138535	k9qs4yUVW/ZPLqGoBPGRJ1RKcieoC8/8gOPZzkN6vVg=	14	23.0	1	9	2015-04-23	15	2	30.0	1	149.0	149.0	0.933333	1	2015-06-12	2017-01-31	15	2017-03-27	4.966667	53.400000	13	1.064211	0.211658	0.187084	0.150600	4.235748	4.165998	9.734375	33	2017-01-18	704

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Math Symbol

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script